/*
 *代码由框架生成,任何更改都可能导致被代码生成器覆盖
 *如果数据库字段发生变化，请在代码生器重新生成此Model
 */
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
using VOL.Entity.SystemModels;

namespace VOL.Entity.DomainModels
{
    [Entity(TableCnName = "替代料管理",TableName = "alternativematerialsmodel")]
    public partial class alternativematerialsmodel:BaseEntity
    {
        /// <summary>
       ///替代料id
       /// </summary>
       [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
       [Key]
       [Display(Name ="替代料id")]
       [Column(TypeName="int")]
       [Editable(true)]
       [Required(AllowEmptyStrings=false)]
       public int AlternativeId { get; set; }

       /// <summary>
       ///源物料编码(外键)
       /// </summary>
       [Display(Name ="源物料编码(外键)")]
       [MaxLength(100)]
       [Column(TypeName="nvarchar(100)")]
       [Editable(true)]
       public string ProductItemId { get; set; }

       /// <summary>
       ///替代物料编码(外键)
       /// </summary>
       [Display(Name ="替代物料编码(外键)")]
       [MaxLength(100)]
       [Column(TypeName="nvarchar(100)")]
       [Editable(true)]
       public string AlternativeMaterialsId { get; set; }

       /// <summary>
       ///工单编码（外键）
       /// </summary>
       [Display(Name ="工单编码（外键）")]
       [Column(TypeName="int")]
       [Editable(true)]
       public int? TicketsId { get; set; }

       /// <summary>
       ///有效开始日期
       /// </summary>
       [Display(Name ="有效开始日期")]
       [Column(TypeName="datetime")]
       [Editable(true)]
       public DateTime? AlternativeMaterialsStartDate { get; set; }

       /// <summary>
       ///有效截止日期
       /// </summary>
       [Display(Name ="有效截止日期")]
       [Column(TypeName="datetime")]
       [Editable(true)]
       public DateTime? AlternativeMaterialsEndDate { get; set; }

       /// <summary>
       ///备注
       /// </summary>
       [Display(Name ="备注")]
       [MaxLength(200)]
       [Column(TypeName="nvarchar(200)")]
       [Editable(true)]
       public string AlternativeMaterialsRemark { get; set; }

       /// <summary>
       ///创建人
       /// </summary>
       [Display(Name ="创建人")]
       [MaxLength(100)]
       [Column(TypeName="nvarchar(100)")]
       [Editable(true)]
       public string CreateUserName { get; set; }

       /// <summary>
       ///修改人
       /// </summary>
       [Display(Name ="修改人")]
       [MaxLength(100)]
       [Column(TypeName="nvarchar(100)")]
       [Editable(true)]
       public string UpdateUserName { get; set; }

       /// <summary>
       ///创建时间
       /// </summary>
       [Display(Name ="创建时间")]
       [Column(TypeName="datetime")]
       [Editable(true)]
       public DateTime? CreateTime { get; set; }

       /// <summary>
       ///更新时间
       /// </summary>
       [Display(Name ="更新时间")]
       [Column(TypeName="datetime")]
       [Editable(true)]
       public DateTime? UpdateTime { get; set; }

       /// <summary>
       ///软删除
       /// </summary>
       [Display(Name ="软删除")]
       [Column(TypeName="sbyte")]
       [Editable(true)]
       public sbyte? IsDeleted { get; set; }

       
    }
}